StudentAward 
EntityType  Dependent 
Logical Entity Name  StudentAward 
Default Table Name  FaStudentAid 
Logical Only  NO 
Definition 
 
Note 
 

StudentAward Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
StudentAwardId(PK)(FK)    INTEGER  NO 
 
StudentId(FK)    INTEGER  NO 
 
StudentEnrollmentPeriodId(FK)    INTEGER  YES 
 
StudentRelationshipAddressId(FK)    INTEGER  YES 
 
Source    CHAR(1)  YES 
 
FundSourceId(FK)    INTEGER  YES 
 
AwardYear    CHAR(7)  YES 
 
AgencyBranchId    INTEGER  YES 
 
FaLenderId(FK)    INTEGER  YES 
 
ServicerLendingInstitutionId    INTEGER  YES 
 
GuarantorLendingInstitutionId    INTEGER  YES 
 
AmountPackaged    MONEY(19, 4)  NO 
 
LenderFee    MONEY(19, 4)  NO 
 
AmountDisbursed    MONEY(19, 4)  NO 
 
AmountCanceled    MONEY(19, 4)  NO 
 
AmountRefunded    MONEY(19, 4)  NO 
 
LoanPeriodBeginDate    DATETIME  YES 
 
LoanPeriodEndDate    DATETIME  YES 
 
ApplicationSentDate    DATETIME  YES 
 
ApplicationReceivedDate    DATETIME  YES 
 
StudentAcademicYearId(FK)    INTEGER  YES 
 
FirstPaymentDate    DATETIME  YES 
 
LastInterestDate    DATETIME  YES 
 
PaymentDay    TINYINT  YES 
 
PaymentFrequency    SMALLINT  YES 
 
InterestRate    NUMERIC(5, 2)  YES 
 
NumberPayments    SMALLINT  YES 
 
TotalAmountPaid    MONEY(19, 4)  YES 
 
PrincipalBalance    MONEY(19, 4)  YES 
 
InterestBalance    MONEY(19, 4)  YES 
 
NextPaymentDate    DATETIME  YES 
 
PaymentAmount    MONEY(19, 4)  YES 
 
Status    CHAR(1)  YES 
 
Note    TEXT  YES 
 
LastModifiedUserId    INTEGER  NO 
 
CreatedDateTime    DATETIME  NO 
 
LastModifiedDateTime    DATETIME  NO 
 
RowVersion    TIMESTAMP/DATE  NO 
 
StudentAwardPellId    INTEGER  YES 
 
IsBankFeeIncludedInCoa    BIT  NO 
 
InterestRebateAmount    NUMERIC(18, 0)  YES 
 
ServicerRecordIdentifier    CHAR(20)  YES 
 
CreatedByUserId    INTEGER  NO 
 
BatchPackagingProcessId(FK)    INTEGER  YES 
 
IsEstimatedAward    BIT  NO 
 
SecondaryInterestRate    NUMERIC(6, 3)  YES 
 
SecondaryInterestRateEffectiveDate    DATETIME  YES 
 
InterestOnlyUntilDate    DATETIME  YES 
 
AccruedInterestAmount    MONEY(19, 4)  NO 
 
IsAutoDraft    BIT  NO 
 
EffectiveDate    DATETIME  YES 
 
StudentBankAccountId(FK)    INTEGER  YES 
 
StudentCreditCardId(FK)    INTEGER  YES 
 
IsAutoCredit    BIT  NO 
 
CreditCardEffectiveDate    DATETIME  YES 
 
IsT4BalanceEvaluated    BIT  NO 
 
LastStatementPrintDate    DATETIME  YES 
 
LastPromNotePrintDate    DATETIME  YES 
 
CodGrantOriginationId(FK)    INTEGER  YES 
 
IsLocked    BIT  NO 
 
LockedByUserId    INTEGER  YES 
 
DownPaymentAmount    MONEY(19, 4)  YES 
 
PromNoteDocumentId    INTEGER  YES 
 
CalculationDate    DATETIME  YES 
 
LoanIdentificationNumber    INTEGER  YES 
 
IsReAllocated    BIT  NO 
 
Rep9010DiscountRate    NUMERIC(5, 2)  YES 
 
Rep9010CollectionRate    NUMERIC(5, 2)  YES 
 
Rep9010NumberOfYears    SMALLMONEY  YES 
 
StudentLoanPeriodId    INTEGER  YES 
 
LoanAcademicYearStartDate    DATETIME  YES 
 
LoanAcademicYearEndDate    DATETIME  YES 
 
IsAXLinkedFWS    BIT  NO 
 
StudentId(FK)    INTEGER  YES 
 
StudentCreditCardId(FK)    INTEGER  YES 
 

StudentAward Keys 
Key Name  Key Type  Keys 
FaStudentAid_DateLoanStart_DateLoanEnd_N_N_IDX  Inversion Entry  LoanPeriodBeginDate, LoanPeriodEndDate 
FaStudentAid_SyStudentID_AwardYear_FaFundSourceID_FaStudentAidID_U_N_IDX  Alternate Key  StudentId, AwardYear, FundSourceId, StudentAwardId 
FaStudentAid_AwardYear_FaStudentAidID_U_N_IDX  Alternate Key  AwardYear, StudentAwardId 
FaStudentAid_FaStudentAYID_N_N_IDX  Inversion Entry  StudentAcademicYearId 
FaStudentAid_FaStudentAidID_U_C_IDX  PrimaryKey  StudentAwardId 
Nk_FaStudentAidPromNoteCMDocumentID_CmDocumentCmDocumentId  Inversion Entry  PromNoteDocumentId 
FaStudentAid_SaStudentBankAccountID_N_N_IDX  Inversion Entry  StudentBankAccountId 
FaStudentAid_SaCcId_N_N_IDX  Inversion Entry  StudentCreditCardId 
FaStudentAid_FaBatchPackageID_N_N_IDX  Inversion Entry  BatchPackagingProcessId 
FaStudentAid_SyStudentID_IsAutoCredit_U_N_IDX  Inversion Entry  StudentId, IsAutoCredit 
FaStudentAid_SyStudentID_IsAutoDraft_U_N_IDX  Inversion Entry  StudentId, IsAutoDraft 
FaStudentAid_Source_N_N_IDX  Inversion Entry  Source 
FaStudentAid_ServicerRecordID_N_N_IDX  Inversion Entry  ServicerRecordIdentifier 
FaStudentAid_FaStudentPellID_N_N_IDX  Inversion Entry  StudentAwardPellId 
FaStudentAid_FaFundSourceID_N_N_IDX  Inversion Entry  FundSourceId 
NK_FaStudentAid_AwardYear_INCL  Inversion Entry  AwardYear 
FaStudentAid_FaCODGrantID_FaStudentAidID_U_N_IDX  Alternate Key  CodGrantOriginationId, StudentAwardId 
FaStudentAid_FaFundSourceID_FaBankID_Source_N_N_IDX  Inversion Entry  StudentAwardId, FaLenderId, Source 
Nk_FaStudentAid_Id_AdEnrollId_StudentAYId_FundSourceId_AwardYear  Inversion Entry  StudentAwardId, StudentAcademicYearId, FundSourceId, AwardYear 
Uk_FaStudentAid_FaFundSourceID_AwardYear_Status_AdEnrollID_FaStudentPellID_SyStudentID_FaStudentAidID  Alternate Key  FundSourceId, AwardYear, Status, StudentAwardPellId, StudentId, StudentAwardId 
FaStudentAid_AdEnrollID_Source_FaFundSourceID_AwardYear_Status_N_N_IDX  Inversion Entry  Source, FundSourceId, AwardYear, Status 
FaStudentAid_Status_FaFundSourceID_AwardYear_FaBankID_AdEnrollID_FaStudentAidID_SyStudentID_N_N_IDX  Inversion Entry  Status, FundSourceId, AwardYear, FaLenderId, StudentAwardId, StudentId 
Nk_FaStudentAid_Id_AdEnrollId_FundSourceId_AwardYear_BankId_LoanDates  Inversion Entry  StudentAwardId, FundSourceId, AwardYear, FaLenderId, GuarantorLendingInstitutionId, LoanPeriodBeginDate, LoanPeriodEndDate 

StudentAward Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
LendingInstitution  Non-Identifying  Zero or One to Zero or More        FaLenderId  NO 
BatchPackagingProcess  Non-Identifying  Zero or One to Zero or More        BatchPackagingProcessId  NO 
CodGrantOrigination  Non-Identifying  Zero or One to Zero or More        CodGrantOriginationId  NO 
FundSource  Non-Identifying  Zero or One to Zero or More        FundSourceId  NO 
StudentAwardPell  Identifying  One To Zero or More        StudentAwardId  NO 
StudentAcademicYear  Non-Identifying  Zero or One to Zero or More        StudentAcademicYearId  NO 
StudentCreditCard  Non-Identifying  Zero or One to Zero or More        StudentCreditCardId  NO 
StudentBankAccount  Non-Identifying  Zero or One to Zero or More        StudentBankAccountId  NO 
Student  Non-Identifying  One To Zero or More        StudentId  NO 
Student  Non-Identifying  Zero or One to Zero or More        StudentId  NO 
StudentCreditCard  Non-Identifying  Zero or One to Zero or More        StudentCreditCardId  NO 
StudentEnrollmentPeriod  Non-Identifying  Zero or One to Zero or More        StudentEnrollmentPeriodId  NO 
StudentRelationshipAddress  Non-Identifying  Zero or One to Zero or More        StudentRelationshipAddressId  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
FaCampusVantageWorkStudyPayroll  Non-Identifying  One To Zero or More          NO 
FaCashPlanWorkflowAudit  Non-Identifying  One To Zero or More          NO 
FaCodActualDisb_REG  Non-Identifying  One To Zero or More          NO 
CodGrantDisbursement  Non-Identifying  One To Zero or More          NO 
PaidDisbursement  Non-Identifying  One To Zero or More          NO 
StudentAwardLoan  Non-Identifying  One To Zero or More          NO 
FaLoanCommonLineChangeSendLog  Non-Identifying  One To Zero or More          NO 
StudentAwardPromNotePrintAssignment  Non-Identifying  One To Zero or More          NO 
FaPromNotePrintAssignmentHistory_FAA  Non-Identifying  One To Zero or More          NO 
Refund  Non-Identifying  One To Zero or More          NO 
StudentAwardCalculation  Non-Identifying  One To Zero or More          NO 
FaStudentAidCashPlanAssignment  Non-Identifying  One To Zero or More          NO 
FaStudentAidCashPlanHistory  Non-Identifying  One To Zero or More          NO 
StudentAwardCalculation  Non-Identifying  One To Zero or More          NO 
StudentAcademicYearPaymentPeriod  Non-Identifying  One To Zero or More          NO 
StudentAcademicYearLoanPaymentPeriod  Non-Identifying  One To Zero or More          NO 
CollectionAccount  Non-Identifying  One To Zero or More          NO 
StudentStatement  Non-Identifying  One To Zero or More          NO 
SyAudit_FaStudentAid  Non-Identifying  One To Zero or More          NO 
FaaProcessSourceRecord  Non-Identifying  One To Zero or More          NO 
CollectionAccount  Non-Identifying  One To Zero or More          NO 
PaidDisbursement  Non-Identifying  One To Zero or More          NO 
Refund  Non-Identifying  One To Zero or More          NO 
ScheduledDisbursement  Non-Identifying  One To Zero or More          NO 
StipendSchedule  Non-Identifying  One To Zero or More          NO 
StudentAccountTransaction  Non-Identifying  One To Zero or More          NO 
StudentRefundCalculationFundSourceSummary  Non-Identifying  One To Zero or More          NO 
StudentRt4CalculationStudentAward  Non-Identifying  One To Zero or More          NO 
StudentStatement  Non-Identifying  One To Zero or More          NO 

StudentAward Check Constraints 
Check Constraint Name  CheckConstraint 
Chk_FaStudentAid_IntOnlyUntilDate  ([IntOnlyUntilDate] is null and [FirstPayDate] is null or [IntOnlyUntilDate] is null and [FirstPayDate] is not null or [IntOnlyUntilDate] is not null and [FirstPayDate] is not null and [IntOnlyUntilDate] > [FirstPayDate]) 
Chk_FaStudentAid_SecondaryInterestRateEffDate  ([SecondaryInterestRateEffDate] is null and [FirstPayDate] is null or [SecondaryInterestRateEffDate] is null and [FirstPayDate] is not null or [SecondaryInterestRateEffDate] is not null and [FirstPayDate] is not null and [SecondaryInterestRateEffDate] > [FirstPayDate])